<?php
class Admin_Model_DbTable_getnextid extends Zend_Db_Table_Abstract
{
	 protected $_name='hae_career';
	 protected $_sequence=true;
     protected $_primary='id';
     
     public function getnextid()
     {
         $tablename = "hae_carrer";
        $abc = $this->select()->query("SHOW TABLE STATUS LIKE ". $tablename);
       
         $qShowStatus = "SHOW TABLE STATUS LIKE '$tablename'";
         $qShowStatusResult = mysql_query($abc);
         
         $row = mysql_fetch_assoc($qShowStatusResult);
         $next_increment = $row['Auto_increment'];
         
         echo "next increment number: [$next_increment]";die;
        
     }
}
?>